package com.mc.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.mc.model.Teacher;

public interface TeacherMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Teacher record);

    int insertSelective(Teacher record);

    Teacher selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Teacher record);

    int updateByPrimaryKey(Teacher record);
    //NAME1 VARCHAR(30),NO1 VARCHAR(20),gender1 char(2),major_id1 int ,
   // phone1 VARCHAR(20),qq1 VARCHAR(15),teachertypeid int,userid int 
    void insertTeacher(@Param("NAME1")String NAME1,@Param("NO1") String NO1,
    		@Param("gender1") String gender1,@Param("major_id1")int major_id1,
    		@Param("phone1") String phone1,@Param("qq1")String qq1,

            @Param("teachertypeid") int teachertypeid,@Param("userid") int userid,
            @Param("intro")String intro);
    /**
     * 得到所有计科教师
     * @return
     */
    List<Teacher> selectAllcteachers();
    /**
     * 得到所有软工教师
     * @return
     */
    List<Teacher> selectAllrteachers();
    /**
     * 得到所有信科教师
     * @return
     */
    List<Teacher> selectAllxteachers();
    /**
     * 得到所有应用数学教师
     * @return
     */
    List<Teacher> selectAllyteachers();
    /**
     * 得到所有物联网教师
     * @return
     */
    List<Teacher> selectAllwteachers();
    List<Teacher> getTeacherByMajorName(String name);
    
    public List<Teacher> getTeacherByTeacherType(String type);
}
      